Previous Topic

Next Topic

Example 2: To search for specific products

You can create meaningful searches to look at the status of open billing balances. For example, if you want to see the balances for specific products, set the PRODUCT_CODE equal to those codes only:

  1. From Billing, select Generate reports to display the Generate reports window.
  2. Select Open Invoices and select Open Items by Product.
  3. Click Options and select Search Format to display the Select Search Instructions window.
  4. Click New to display the Search Instructions window.
  5. Enter the new search instructions.
    • To search for product codes with a balance:
      Subscription.PRODUCT_CODE = BASIC,JOUR
      Subscription.BALANCE <> 0
    • To specify comparisons for the codes to be excluded:
      Subscription.PRODUCT_CODE <> PAC,SCHOL
      Subscription.BALANCE <> 0p
    • To print open items for an entire group or type of product, such as all open subscription lines:
      Product.PROD_TYP = SUB
      Subscription.BALANCE <> 0
  6. Click Save to accept the search instructions, and close the Search Instructions window.
  7. Click OK to close the Select Search Selections window.
  8. Click Run to generate the report.

See Also

Examples of Ad Hoc Searches

Example 1: To search by bill date

Example 3: To search by customer type


ASI logo 10.6 Production Release. Updated 9/21/2005 11:40:30 AM
© 2009 by Advanced Solutions International, Inc. All rights reserved.